# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月11日
"""
import pandas as pd

path = '../数据文件/课件015-016/填充.xlsx'

data = pd.read_excel(path)

# print(data)
# print(data.fillna(method='ffill'))
# print(data.fillna(method='bfill'))
# print(data.fillna(method='pad'))
print(data.fillna(method='backfill',limit=2))